利用pandas库和ttk.Treeviews制作xlxs视图工具

参考文章:

https://blog.csdn.net/weixin_42268054/article/details/82902296
https://blog.csdn.net/qq_39410381/article/details/88867533

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
import tkinter as tk
from tkinter import ttk
import pandas as pd

def Start():
fp = pd.read_excel("./test.xlsx")
for _ in range(len(fp.index.values)):
tree.insert('','end',value=tuple(fp.iloc[_,[1,2]].values))


win = tk.Tk()
win.wm_attributes('-topmost',1)
# win.geometry("+1300+0")

ttk.Button(win,text="Import it",command=Start).pack()

columns = ("name","gender")

tree = ttk.Treeview(win,show="headings",columns=columns)
tree.column("name",width=100,anchor='center')
tree.column("gender",width=50, anchor="center")

tree.heading("name",text="name")
tree.heading("gender",text="gender")


tree.pack()


win.mainloop()

excel图片:
在这里插入图片描述

结果显示:
在这里插入图片描述